Nuveen Profile report

Dataset statistics

Number of variables	41
Number of observations	10005
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1965
Duplicate rows (%)	19.6%
Total size in memory	1.9 MiB
Average record size in memory	203.0 B

Variable types

Numeric	21
Categorical	20

Warnings

Dataset has 1965 (19.6%) duplicate rows	Duplicates
`Sub channel_IBD` is highly correlated with `Sub channel_NACS`	High correlation
`Sub channel_NACS` is highly correlated with `Sub channel_IBD`	High correlation
`Sub channel_NACS` is highly correlated with `Sub channel_IBD`	High correlation
`Sub channel_IBD` is highly correlated with `Sub channel_NACS`	High correlation
`no_of_Redemption_12M_1` is highly skewed (γ1 = 52.12310105)	Skewed
`no_of_sales_12M_10K` is highly skewed (γ1 = 36.02830336)	Skewed
`no_of_Redemption_12M_10K` is highly skewed (γ1 = 42.62915028)	Skewed
`AUM` is highly skewed (γ1 = 45.17108772)	Skewed
`sales_curr` is highly skewed (γ1 = 27.7623075)	Skewed
`sales_12M` is highly skewed (γ1 = 25.89467679)	Skewed
`redemption_curr` is highly skewed (γ1 = -39.74234212)	Skewed
`redemption_12M` is highly skewed (γ1 = -27.16514523)	Skewed
`no_of_sales_12M_1` has 5242 (52.4%) zeros	Zeros
`no_of_Redemption_12M_1` has 4644 (46.4%) zeros	Zeros
`no_of_sales_12M_10K` has 7293 (72.9%) zeros	Zeros
`no_of_Redemption_12M_10K` has 7029 (70.3%) zeros	Zeros
`no_of_funds_sold_12M_1` has 5242 (52.4%) zeros	Zeros
`no_of_funds_redeemed_12M_1` has 4644 (46.4%) zeros	Zeros
`no_of_fund_sales_12M_10K` has 7293 (72.9%) zeros	Zeros
`no_of_funds_Redemption_12M_10K` has 7029 (70.3%) zeros	Zeros
`no_of_assetclass_sold_12M_1` has 5242 (52.4%) zeros	Zeros
`no_of_assetclass_redeemed_12M_1` has 4644 (46.4%) zeros	Zeros
`no_of_assetclass_sales_12M_10K` has 7293 (72.9%) zeros	Zeros
`No_of_fund_curr` has 3822 (38.2%) zeros	Zeros
`No_of_asset_curr` has 4426 (44.2%) zeros	Zeros
`AUM` has 4989 (49.9%) zeros	Zeros
`sales_curr` has 7580 (75.8%) zeros	Zeros
`sales_12M` has 5248 (52.5%) zeros	Zeros
`redemption_curr` has 7430 (74.3%) zeros	Zeros
`redemption_12M` has 4628 (46.3%) zeros	Zeros
`new_Fund_added_12M` has 7310 (73.1%) zeros	Zeros
`sales_2019` has 4935 (49.3%) zeros	Zeros
`new_fund_2019` has 7484 (74.8%) zeros	Zeros

Reproduction

Analysis started	2021-02-13 10:51:25.454930
Analysis finished	2021-02-13 10:52:44.735945
Duration	1 minute and 19.28 seconds
Software version	pandas-profiling v2.10.1
Download configuration	config.yaml

no_of_sales_12M_1
Real number (ℝ_≥0)

ZEROS

Distinct	343
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.08215892
Minimum	0
Maximum	4395
Zeros	5242
Zeros (%)	52.4%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	8
95-th percentile	88
Maximum	4395
Range	4395
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	98.44040858
Coefficient of variation (CV)	4.901883755
Kurtosis	608.0439242
Mean	20.08215892
Median Absolute Deviation (MAD)	0
Skewness	19.30971489
Sum	200922
Variance	9690.514041
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5242	52.4%
1	671	6.7%
2	413	4.1%
3	325	3.2%
4	244	2.4%
5	210	2.1%
6	145	1.4%
7	139	1.4%
12	135	1.3%
9	133	1.3%
Other values (333)	2348	23.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5242	52.4%
1	671	6.7%
2	413	4.1%
3	325	3.2%
4	244	2.4%

Value	Count	Frequency (%)
4395	1	< 0.1%
3238	1	< 0.1%
2447	1	< 0.1%
1935	1	< 0.1%
1750	1	< 0.1%

no_of_Redemption_12M_1
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	338
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.97641179
Minimum	0
Maximum	12152
Zeros	4644
Zeros (%)	46.4%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	8
95-th percentile	83
Maximum	12152
Range	12152
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	191.5516344
Coefficient of variation (CV)	9.131763633
Kurtosis	3201.595161
Mean	20.97641179
Median Absolute Deviation (MAD)	1
Skewness	52.12310105
Sum	209869
Variance	36692.02863
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4644	46.4%
1	1002	10.0%
2	554	5.5%
3	384	3.8%
4	290	2.9%
5	250	2.5%
6	193	1.9%
7	147	1.5%
8	137	1.4%
9	129	1.3%
Other values (328)	2275	22.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4644	46.4%
1	1002	10.0%
2	554	5.5%
3	384	3.8%
4	290	2.9%

Value	Count	Frequency (%)
12152	1	< 0.1%
12073	1	< 0.1%
3939	1	< 0.1%
3250	1	< 0.1%
1547	1	< 0.1%

no_of_sales_12M_10K
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	103
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.420089955
Minimum	0
Maximum	986
Zeros	7293
Zeros (%)	72.9%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	11
Maximum	986
Range	986
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	14.53480072
Coefficient of variation (CV)	6.005892753
Kurtosis	2165.850275
Mean	2.420089955
Median Absolute Deviation (MAD)	0
Skewness	36.02830336
Sum	24213
Variance	211.260432
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7293	72.9%
1	807	8.1%
2	466	4.7%
3	241	2.4%
4	183	1.8%
5	149	1.5%
6	100	1.0%
7	85	0.8%
9	61	0.6%
8	59	0.6%
Other values (93)	561	5.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7293	72.9%
1	807	8.1%
2	466	4.7%
3	241	2.4%
4	183	1.8%

Value	Count	Frequency (%)
986	1	< 0.1%
330	1	< 0.1%
289	1	< 0.1%
217	1	< 0.1%
206	1	< 0.1%

no_of_Redemption_12M_10K
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	84
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.856371814
Minimum	0
Maximum	883
Zeros	7029
Zeros (%)	70.3%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	8
Maximum	883
Range	883
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	12.23370734
Coefficient of variation (CV)	6.590116939
Kurtosis	2775.260031
Mean	1.856371814
Median Absolute Deviation (MAD)	0
Skewness	42.62915028
Sum	18573
Variance	149.6635952
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7029	70.3%
1	1149	11.5%
2	529	5.3%
3	295	2.9%
4	175	1.7%
5	136	1.4%
6	90	0.9%
7	74	0.7%
8	71	0.7%
9	61	0.6%
Other values (74)	396	4.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7029	70.3%
1	1149	11.5%
2	529	5.3%
3	295	2.9%
4	175	1.7%

Value	Count	Frequency (%)
883	1	< 0.1%
283	1	< 0.1%
282	1	< 0.1%
205	1	< 0.1%
182	1	< 0.1%

no_of_funds_sold_12M_1
Real number (ℝ_≥0)

ZEROS

Distinct	26
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.35992004
Minimum	0
Maximum	32
Zeros	5242
Zeros (%)	52.4%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	6
Maximum	32
Range	32
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.379879674
Coefficient of variation (CV)	1.750014416
Kurtosis	15.74681138
Mean	1.35992004
Median Absolute Deviation (MAD)	0
Skewness	3.242818486
Sum	13606
Variance	5.663827263
Monotocity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	5242	52.4%
1	1946	19.5%
2	1045	10.4%
3	591	5.9%
4	365	3.6%
5	213	2.1%
6	178	1.8%
7	110	1.1%
8	70	0.7%
9	64	0.6%
Other values (16)	181	1.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5242	52.4%
1	1946	19.5%
2	1045	10.4%
3	591	5.9%
4	365	3.6%

Value	Count	Frequency (%)
32	1	< 0.1%
27	1	< 0.1%
23	1	< 0.1%
22	2	< 0.1%
21	2	< 0.1%

no_of_funds_redeemed_12M_1
Real number (ℝ_≥0)

ZEROS

Distinct	26
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.544327836
Minimum	0
Maximum	33
Zeros	4644
Zeros (%)	46.4%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	6
Maximum	33
Range	33
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.467776953
Coefficient of variation (CV)	1.597961842
Kurtosis	15.22035199
Mean	1.544327836
Median Absolute Deviation (MAD)	1
Skewness	3.121370058
Sum	15451
Variance	6.089923091
Monotocity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	4644	46.4%
1	2062	20.6%
2	1254	12.5%
3	676	6.8%
4	450	4.5%
5	271	2.7%
6	196	2.0%
7	113	1.1%
8	76	0.8%
9	65	0.6%
Other values (16)	198	2.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4644	46.4%
1	2062	20.6%
2	1254	12.5%
3	676	6.8%
4	450	4.5%

Value	Count	Frequency (%)
33	1	< 0.1%
27	1	< 0.1%
25	1	< 0.1%
23	1	< 0.1%
21	7	0.1%

no_of_fund_sales_12M_10K
Real number (ℝ_≥0)

ZEROS

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5703148426
Minimum	0
Maximum	19
Zeros	7293
Zeros (%)	72.9%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	19
Range	19
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.329913863
Coefficient of variation (CV)	2.331894181
Kurtosis	24.80068573
Mean	0.5703148426
Median Absolute Deviation (MAD)	0
Skewness	4.098908602
Sum	5706
Variance	1.768670882
Monotocity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	7293	72.9%
1	1424	14.2%
2	616	6.2%
3	300	3.0%
4	144	1.4%
5	75	0.7%
6	54	0.5%
7	36	0.4%
8	21	0.2%
9	13	0.1%
Other values (7)	29	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7293	72.9%
1	1424	14.2%
2	616	6.2%
3	300	3.0%
4	144	1.4%

Value	Count	Frequency (%)
19	1	< 0.1%
17	1	< 0.1%
16	1	< 0.1%
13	2	< 0.1%
12	6	0.1%

no_of_funds_Redemption_12M_10K
Real number (ℝ_≥0)

ZEROS

Distinct	19
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.607896052
Minimum	0
Maximum	21
Zeros	7029
Zeros (%)	70.3%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	21
Range	21
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.358727039
Coefficient of variation (CV)	2.235130553
Kurtosis	34.15335594
Mean	0.607896052
Median Absolute Deviation (MAD)	0
Skewness	4.47196549
Sum	6082
Variance	1.846139166
Monotocity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0	7029	70.3%
1	1630	16.3%
2	645	6.4%
3	284	2.8%
4	197	2.0%
5	81	0.8%
6	56	0.6%
7	30	0.3%
8	13	0.1%
10	11	0.1%
Other values (9)	29	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7029	70.3%
1	1630	16.3%
2	645	6.4%
3	284	2.8%
4	197	2.0%

Value	Count	Frequency (%)
21	2	< 0.1%
20	1	< 0.1%
17	2	< 0.1%
16	1	< 0.1%
15	1	< 0.1%

no_of_assetclass_sold_12M_1
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.7862068966
Minimum	0
Maximum	5
Zeros	5242
Zeros (%)	52.4%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.004771531
Coefficient of variation (CV)	1.277998877
Kurtosis	0.6534995107
Mean	0.7862068966
Median Absolute Deviation (MAD)	0
Skewness	1.185360917
Sum	7866
Variance	1.009565829
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	5242	52.4%
1	2615	26.1%
2	1336	13.4%
3	677	6.8%
4	127	1.3%
5	8	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5242	52.4%
1	2615	26.1%
2	1336	13.4%
3	677	6.8%
4	127	1.3%

Value	Count	Frequency (%)
5	8	0.1%
4	127	1.3%
3	677	6.8%
2	1336	13.4%
1	2615	26.1%

no_of_assetclass_redeemed_12M_1
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.9067466267
Minimum	0
Maximum	5
Zeros	4644
Zeros (%)	46.4%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	3
Maximum	5
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.046786108
Coefficient of variation (CV)	1.15444169
Kurtosis	0.1890241434
Mean	0.9067466267
Median Absolute Deviation (MAD)	1
Skewness	0.9957527068
Sum	9072
Variance	1.095761156
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	4644	46.4%
1	2805	28.0%
2	1585	15.8%
3	795	7.9%
4	168	1.7%
5	8	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4644	46.4%
1	2805	28.0%
2	1585	15.8%
3	795	7.9%
4	168	1.7%

Value	Count	Frequency (%)
5	8	0.1%
4	168	1.7%
3	795	7.9%
2	1585	15.8%
1	2805	28.0%

no_of_assetclass_sales_12M_10K
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.3787106447
Minimum	0
Maximum	5
Zeros	7293
Zeros (%)	72.9%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.709087734
Coefficient of variation (CV)	1.872373391
Kurtosis	4.297082837
Mean	0.3787106447
Median Absolute Deviation (MAD)	0
Skewness	2.058515187
Sum	3789
Variance	0.5028054146
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	7293	72.9%
1	1861	18.6%
2	659	6.6%
3	159	1.6%
4	32	0.3%
5	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7293	72.9%
1	1861	18.6%
2	659	6.6%
3	159	1.6%
4	32	0.3%

Value	Count	Frequency (%)
5	1	< 0.1%
4	32	0.3%
3	159	1.6%
2	659	6.6%
1	1861	18.6%

no_of_assetclass_Redemption_12M_10K
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0.0	7029
1.0	2012
2.0	716
3.0	212
4.0	36

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	30015
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Value	Count	Frequency (%)
0.0	7029	70.3%
1.0	2012	20.1%
2.0	716	7.2%
3.0	212	2.1%
4.0	36	0.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	7029	70.3%
1.0	2012	20.1%
2.0	716	7.2%
3.0	212	2.1%
4.0	36	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	17034	56.8%
.	10005	33.3%
1	2012	6.7%
2	716	2.4%
3	212	0.7%
4	36	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	20010	66.7%
Other Punctuation	10005	33.3%

Most frequent character per category

Value	Count	Frequency (%)
0	17034	85.1%
1	2012	10.1%
2	716	3.6%
3	212	1.1%
4	36	0.2%

Value	Count	Frequency (%)
.	10005	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	30015	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	17034	56.8%
.	10005	33.3%
1	2012	6.7%
2	716	2.4%
3	212	0.7%
4	36	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30015	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	17034	56.8%
.	10005	33.3%
1	2012	6.7%
2	716	2.4%
3	212	0.7%
4	36	0.1%

No_of_fund_curr
Real number (ℝ_≥0)

ZEROS

Distinct	30
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.144127936
Minimum	0
Maximum	32
Zeros	3822
Zeros (%)	38.2%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	3
95-th percentile	9
Maximum	32
Range	32
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.136571619
Coefficient of variation (CV)	1.462865889
Kurtosis	9.284846655
Mean	2.144127936
Median Absolute Deviation (MAD)	1
Skewness	2.565274298
Sum	21452
Variance	9.838081519
Monotocity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
0	3822	38.2%
1	2204	22.0%
2	1174	11.7%
3	745	7.4%
4	525	5.2%
5	373	3.7%
6	271	2.7%
7	192	1.9%
8	169	1.7%
9	125	1.2%
Other values (20)	405	4.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3822	38.2%
1	2204	22.0%
2	1174	11.7%
3	745	7.4%
4	525	5.2%

Value	Count	Frequency (%)
32	1	< 0.1%
31	1	< 0.1%
28	1	< 0.1%
27	3	< 0.1%
26	1	< 0.1%

No_of_asset_curr
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.92003998
Minimum	0
Maximum	6
Zeros	4426
Zeros (%)	44.2%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	3
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.042385999
Coefficient of variation (CV)	1.132979024
Kurtosis	0.7789258605
Mean	0.92003998
Median Absolute Deviation (MAD)	1
Skewness	1.098522688
Sum	9205
Variance	1.086568571
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	4426	44.2%
1	3099	31.0%
2	1595	15.9%
3	656	6.6%
4	199	2.0%
5	28	0.3%
6	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4426	44.2%
1	3099	31.0%
2	1595	15.9%
3	656	6.6%
4	199	2.0%

Value	Count	Frequency (%)
6	2	< 0.1%
5	28	0.3%
4	199	2.0%
3	656	6.6%
2	1595	15.9%

AUM
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	4987
Distinct (%)	49.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	485000.2156
Minimum	0
Maximum	223241111.2
Zeros	4989
Zeros (%)	49.9%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	23.918116
Q3	148411.4636
95-th percentile	2144665.761
Maximum	223241111.2
Range	223241111.2
Interquartile range (IQR)	148411.4636

Descriptive statistics

Standard deviation	2993438.353
Coefficient of variation (CV)	6.172035098
Kurtosis	3129.769006
Mean	485000.2156
Median Absolute Deviation (MAD)	23.918116
Skewness	45.17108772
Sum	4852427157
Variance	8.960673173 × 10¹²
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4989	49.9%
25000	4	< 0.1%
100000	4	< 0.1%
50000	3	< 0.1%
10000	3	< 0.1%
15000	3	< 0.1%
6000	3	< 0.1%
9700	3	< 0.1%
200000	2	< 0.1%
9500	2	< 0.1%
Other values (4977)	4989	49.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4989	49.9%
0.04	1	< 0.1%
0.24	1	< 0.1%
1.28	1	< 0.1%
1.485	1	< 0.1%

Value	Count	Frequency (%)
223241111.2	1	< 0.1%
79736965.08	1	< 0.1%
37991686.2	1	< 0.1%
33271675.07	1	< 0.1%
32227317.4	1	< 0.1%

sales_curr
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	2315
Distinct (%)	23.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	17293.53807
Minimum	0
Maximum	9639535
Zeros	7580
Zeros (%)	75.8%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	35000
Maximum	9639535
Range	9639535
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	194098.5023
Coefficient of variation (CV)	11.22375893
Kurtosis	991.702126
Mean	17293.53807
Median Absolute Deviation (MAD)	0
Skewness	27.7623075
Sum	173021848.3
Variance	3.767422861 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7580	75.8%
25000	7	0.1%
35000	6	0.1%
50	6	0.1%
250	6	0.1%
50000	5	< 0.1%
150	5	< 0.1%
100000	5	< 0.1%
10000	5	< 0.1%
300	4	< 0.1%
Other values (2305)	2376	23.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7580	75.8%
0.51	1	< 0.1%
2.56	1	< 0.1%
3	1	< 0.1%
4.777622	1	< 0.1%

Value	Count	Frequency (%)
9639535	1	< 0.1%
6119333.41	1	< 0.1%
6012961.99	1	< 0.1%
5273295.217	1	< 0.1%
5270473.645	1	< 0.1%

sales_12M
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	4622
Distinct (%)	46.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	173095.4214
Minimum	0
Maximum	54346496.96
Zeros	5248
Zeros (%)	52.5%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	31557.195
95-th percentile	689511.4126
Maximum	54346496.96
Range	54346496.96
Interquartile range (IQR)	31557.195

Descriptive statistics

Standard deviation	1129623.71
Coefficient of variation (CV)	6.526017273
Kurtosis	1000.896648
Mean	173095.4214
Median Absolute Deviation (MAD)	0
Skewness	25.89467679
Sum	1731819691
Variance	1.276049725 × 10¹²
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5248	52.5%
20000	14	0.1%
25000	11	0.1%
50000	10	0.1%
10000	9	0.1%
100000	8	0.1%
5000	7	0.1%
15000	6	0.1%
35000	6	0.1%
6000	6	0.1%
Other values (4612)	4680	46.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5248	52.5%
0.015	1	< 0.1%
0.18	1	< 0.1%
0.48	1	< 0.1%
1.06	1	< 0.1%

Value	Count	Frequency (%)
54346496.96	1	< 0.1%
49288520.5	1	< 0.1%
29963424.5	1	< 0.1%
27510447	1	< 0.1%
17934270.48	1	< 0.1%

redemption_curr
Real number (ℝ)

SKEWED
ZEROS

Distinct	2447
Distinct (%)	24.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-18525.40367
Minimum	-13208846.26
Maximum	447745.8104
Zeros	7430
Zeros (%)	74.3%
Memory size	156.3 KiB

Quantile statistics

Minimum	-13208846.26
5-th percentile	-54530.12
Q1	-11.03
median	0
Q3	0
95-th percentile	0
Maximum	447745.8104
Range	13656592.07
Interquartile range (IQR)	11.03

Descriptive statistics

Standard deviation	196813.9931
Coefficient of variation (CV)	-10.62400564
Kurtosis	2239.070837
Mean	-18525.40367
Median Absolute Deviation (MAD)	0
Skewness	-39.74234212
Sum	-185346663.7
Variance	3.873574789 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7430	74.3%
-15	16	0.2%
-30	10	0.1%
-1000	9	0.1%
-1500	8	0.1%
-500	8	0.1%
-2500	7	0.1%
-4000	6	0.1%
-5000	6	0.1%
-6000	5	< 0.1%
Other values (2437)	2500	25.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-13208846.26	1	< 0.1%
-5664250.175	1	< 0.1%
-5283473.5	1	< 0.1%
-5244763.26	1	< 0.1%
-4610505.08	1	< 0.1%

Value	Count	Frequency (%)
447745.8104	1	< 0.1%
39.88	1	< 0.1%
0.5	1	< 0.1%
0	7430	74.3%
-0.01	1	< 0.1%

redemption_12M
Real number (ℝ)

SKEWED
ZEROS

Distinct	5266
Distinct (%)	52.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-123897.3797
Minimum	-46703684.94
Maximum	748167.23
Zeros	4628
Zeros (%)	46.3%
Memory size	156.3 KiB

Quantile statistics

Minimum	-46703684.94
5-th percentile	-462443.614
Q1	-33331.9998
median	-514.795
Q3	0
95-th percentile	0
Maximum	748167.23
Range	47451852.16
Interquartile range (IQR)	33331.9998

Descriptive statistics

Standard deviation	890215.0835
Coefficient of variation (CV)	-7.185100167
Kurtosis	1058.102763
Mean	-123897.3797
Median Absolute Deviation (MAD)	514.795
Skewness	-27.16514523
Sum	-1239593284
Variance	7.924828949 × 10¹¹
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	46.3%
-15	10	0.1%
-10000	10	0.1%
-30	9	0.1%
-20000	6	0.1%
-3000	6	0.1%
-50000	5	< 0.1%
-500	5	< 0.1%
-4000	5	< 0.1%
-5000	5	< 0.1%
Other values (5256)	5316	53.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-46703684.94	1	< 0.1%
-30732377.97	1	< 0.1%
-25230422.69	1	< 0.1%
-20268146.98	1	< 0.1%
-19437733.32	1	< 0.1%

Value	Count	Frequency (%)
748167.23	1	< 0.1%
196805	1	< 0.1%
61307.27835	1	< 0.1%
0.96	1	< 0.1%
0	4628	46.3%

new_Fund_added_12M
Real number (ℝ_≥0)

ZEROS

Distinct	16
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4925537231
Minimum	0
Maximum	16
Zeros	7310
Zeros (%)	73.1%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	16
Range	16
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.199372389
Coefficient of variation (CV)	2.43500827
Kurtosis	34.28015658
Mean	0.4925537231
Median Absolute Deviation (MAD)	0
Skewness	4.88793048
Sum	4928
Variance	1.438494128
Monotocity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	7310	73.1%
1	1690	16.9%
2	547	5.5%
3	230	2.3%
4	72	0.7%
5	50	0.5%
6	23	0.2%
7	20	0.2%
9	18	0.2%
10	15	0.1%
Other values (6)	30	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7310	73.1%
1	1690	16.9%
2	547	5.5%
3	230	2.3%
4	72	0.7%

Value	Count	Frequency (%)
16	1	< 0.1%
14	3	< 0.1%
13	3	< 0.1%
12	6	0.1%
11	7	0.1%

sales_2019
Real number (ℝ_≥0)

ZEROS

Distinct	4911
Distinct (%)	49.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	214009.8062
Minimum	0
Maximum	48676376.97
Zeros	4935
Zeros (%)	49.3%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	89.89
Q3	45279.95
95-th percentile	910365.526
Maximum	48676376.97
Range	48676376.97
Interquartile range (IQR)	45279.95

Descriptive statistics

Standard deviation	1155078.948
Coefficient of variation (CV)	5.397317855
Kurtosis	482.3381763
Mean	214009.8062
Median Absolute Deviation (MAD)	89.89
Skewness	17.32606132
Sum	2141168111
Variance	1.334207376 × 10¹²
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4935	49.3%
25000	17	0.2%
50000	11	0.1%
20000	9	0.1%
10000	7	0.1%
125000	6	0.1%
100000	6	0.1%
40000	6	0.1%
5000	6	0.1%
75000	5	< 0.1%
Other values (4901)	4997	49.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4935	49.3%
0.01	1	< 0.1%
0.4	1	< 0.1%
0.42	1	< 0.1%
0.855	1	< 0.1%

Value	Count	Frequency (%)
48676376.97	1	< 0.1%
31360821.6	1	< 0.1%
28091393.74	1	< 0.1%
26884452.7	1	< 0.1%
19140606.52	1	< 0.1%

new_fund_2019
Real number (ℝ_≥0)

ZEROS

Distinct	16
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4349825087
Minimum	0
Maximum	20
Zeros	7484
Zeros (%)	74.8%
Memory size	156.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	20
Range	20
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.111216312
Coefficient of variation (CV)	2.554622978
Kurtosis	47.68455821
Mean	0.4349825087
Median Absolute Deviation (MAD)	0
Skewness	5.572591958
Sum	4352
Variance	1.234801692
Monotocity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	7484	74.8%
1	1687	16.9%
2	461	4.6%
3	184	1.8%
4	75	0.7%
5	32	0.3%
6	18	0.2%
10	12	0.1%
11	11	0.1%
8	11	0.1%
Other values (6)	30	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7484	74.8%
1	1687	16.9%
2	461	4.6%
3	184	1.8%
4	75	0.7%

Value	Count	Frequency (%)
20	1	< 0.1%
15	2	< 0.1%
13	2	< 0.1%
12	5	< 0.1%
11	11	0.1%

Channel_Asset Manager
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9957
1	48

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	9957	99.5%
1	48	0.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9957	99.5%
1	48	0.5%

Most occurring characters

Value	Count	Frequency (%)
0	9957	99.5%
1	48	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9957	99.5%
1	48	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9957	99.5%
1	48	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9957	99.5%
1	48	0.5%

Channel_Bank/Trust
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9824
1	181

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	9824	98.2%
1	181	1.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9824	98.2%
1	181	1.8%

Most occurring characters

Value	Count	Frequency (%)
0	9824	98.2%
1	181	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9824	98.2%
1	181	1.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9824	98.2%
1	181	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9824	98.2%
1	181	1.8%

Channel_Discount
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9986
1	19

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	9986	99.8%
1	19	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9986	99.8%
1	19	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	9986	99.8%
1	19	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9986	99.8%
1	19	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9986	99.8%
1	19	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9986	99.8%
1	19	0.2%

Channel_Dual
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9529
1	476

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	9529	95.2%
1	476	4.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9529	95.2%
1	476	4.8%

Most occurring characters

Value	Count	Frequency (%)
0	9529	95.2%
1	476	4.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9529	95.2%
1	476	4.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9529	95.2%
1	476	4.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9529	95.2%
1	476	4.8%

Channel_Fee-Based Adviser
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9765
1	240

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	9765	97.6%
1	240	2.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9765	97.6%
1	240	2.4%

Most occurring characters

Value	Count	Frequency (%)
0	9765	97.6%
1	240	2.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9765	97.6%
1	240	2.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9765	97.6%
1	240	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9765	97.6%
1	240	2.4%

Channel_Independent Dealer
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

1	6942
0	3063

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	6942	69.4%
0	3063	30.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	6942	69.4%
0	3063	30.6%

Most occurring characters

Value	Count	Frequency (%)
1	6942	69.4%
0	3063	30.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	6942	69.4%
0	3063	30.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	6942	69.4%
0	3063	30.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	6942	69.4%
0	3063	30.6%

Channel_International Outlet
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9998
1	7

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Channel_Low/Non Producer
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	10004
1	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	10004	> 99.9%
1	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	10004	> 99.9%
1	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	10004	> 99.9%
1	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	10004	> 99.9%
1	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	10004	> 99.9%
1	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	10004	> 99.9%
1	1	< 0.1%

Channel_National Broker-Dealer
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	7974
1	2031

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	7974	79.7%
1	2031	20.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	7974	79.7%
1	2031	20.3%

Most occurring characters

Value	Count	Frequency (%)
0	7974	79.7%
1	2031	20.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	7974	79.7%
1	2031	20.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	7974	79.7%
1	2031	20.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	7974	79.7%
1	2031	20.3%

Channel_Networker
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9994
1	11

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	9994	99.9%
1	11	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9994	99.9%
1	11	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	9994	99.9%
1	11	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9994	99.9%
1	11	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9994	99.9%
1	11	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9994	99.9%
1	11	0.1%

Channel_Private Client Group
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9956
1	49

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	9956	99.5%
1	49	0.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9956	99.5%
1	49	0.5%

Most occurring characters

Value	Count	Frequency (%)
0	9956	99.5%
1	49	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9956	99.5%
1	49	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9956	99.5%
1	49	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9956	99.5%
1	49	0.5%

Sub channel_Affiliated
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9998
1	7

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9998	99.9%
1	7	0.1%

Sub channel_DCIO
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	10002
1	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Sub channel_Global
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	10002
1	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Sub channel_IBD
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

1	6679
0	3326

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	1
5th row	0

Value	Count	Frequency (%)
1	6679	66.8%
0	3326	33.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	6679	66.8%
0	3326	33.2%

Most occurring characters

Value	Count	Frequency (%)
1	6679	66.8%
0	3326	33.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	6679	66.8%
0	3326	33.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	6679	66.8%
0	3326	33.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	6679	66.8%
0	3326	33.2%

Sub channel_NACS
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	6930
1	3075

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	6930	69.3%
1	3075	30.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	6930	69.3%
1	3075	30.7%

Most occurring characters

Value	Count	Frequency (%)
0	6930	69.3%
1	3075	30.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	6930	69.3%
1	3075	30.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	6930	69.3%
1	3075	30.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	6930	69.3%
1	3075	30.7%

Sub channel_Other
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	10002
1	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	10002	> 99.9%
1	3	< 0.1%

Sub channel_RIA
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9786
1	219

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	1

Value	Count	Frequency (%)
0	9786	97.8%
1	219	2.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9786	97.8%
1	219	2.2%

Most occurring characters

Value	Count	Frequency (%)
0	9786	97.8%
1	219	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9786	97.8%
1	219	2.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9786	97.8%
1	219	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9786	97.8%
1	219	2.2%

Sub channel_USBT
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.3 KiB

0	9989
1	16

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10005
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	9989	99.8%
1	16	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	9989	99.8%
1	16	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	9989	99.8%
1	16	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10005	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	9989	99.8%
1	16	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	10005	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	9989	99.8%
1	16	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	9989	99.8%
1	16	0.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	no_of_sales_12M_1	no_of_Redemption_12M_1	no_of_sales_12M_10K	no_of_Redemption_12M_10K	no_of_funds_sold_12M_1	no_of_funds_redeemed_12M_1	no_of_fund_sales_12M_10K	no_of_funds_Redemption_12M_10K	no_of_assetclass_sold_12M_1	no_of_assetclass_redeemed_12M_1	no_of_assetclass_sales_12M_10K	no_of_assetclass_Redemption_12M_10K	No_of_fund_curr	No_of_asset_curr	AUM	sales_curr	sales_12M	redemption_curr	redemption_12M	new_Fund_added_12M	sales_2019	new_fund_2019	Channel_Dual	Channel_Independent Dealer	Channel_National Broker-Dealer	Sub channel_IBD	Sub channel_NACS	Sub channel_RIA
0	21.0	38.0	0.0	1.0	5.0	5.0	0.0	1.0	2.0	2.0	0.0	1.0	8.0	1.0	237480.11	250.00	19682.000	-1496.745	-102496.165000	0.0	18633.105	0.0	0	0	1	0	1	0
1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	1.0	19629.00	0.00	0.000	0.000	0.000000	0.0	0.000	0.0	1	0	0	1	0	0
2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1758.70	0.00	0.000	0.000	0.000000	0.0	0.000	0.0	0	1	0	0	0	1
3	20.0	0.0	2.0	0.0	1.0	0.0	1.0	0.0	1.0	0.0	1.0	0.0	1.0	1.0	57943.00	5459.00	52484.000	0.000	0.000000	1.0	93212.000	1.0	0	1	0	1	0	0
4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.00	0.00	0.000	0.000	0.000000	0.0	0.000	0.0	0	1	0	0	0	1
5	71.0	55.0	20.0	4.0	7.0	7.0	6.0	4.0	2.0	2.0	2.0	2.0	12.0	2.0	0.00	46936.63	1274249.925	-18231.645	-178484.290000	2.0	467693.045	0.0	0	0	1	0	1	0
6	16.0	16.0	2.0	0.0	5.0	5.0	2.0	0.0	3.0	3.0	1.0	0.0	20.0	4.0	2649249.57	0.00	175442.490	-20488.060	-56948.290000	2.0	106907.080	0.0	0	0	1	0	1	0
7	6.0	0.0	0.0	0.0	2.0	0.0	0.0	0.0	2.0	0.0	0.0	0.0	5.0	1.0	0.00	0.00	9737.110	0.000	0.000000	0.0	2971.720	0.0	0	1	0	0	1	0
8	5.0	4.0	0.0	0.0	1.0	1.0	0.0	0.0	1.0	1.0	0.0	0.0	0.0	0.0	0.00	0.00	10060.800	0.000	-6752.526579	0.0	0.000	0.0	0	0	1	0	1	0
9	1.0	4.0	0.0	1.0	1.0	1.0	0.0	1.0	1.0	1.0	0.0	1.0	3.0	0.0	0.00	0.00	981.870	-14232.470	-62091.950000	1.0	10000.000	1.0	0	1	0	0	1	0

Last rows

	no_of_sales_12M_1	no_of_Redemption_12M_1	no_of_sales_12M_10K	no_of_Redemption_12M_10K	no_of_funds_sold_12M_1	no_of_funds_redeemed_12M_1	no_of_fund_sales_12M_10K	no_of_funds_Redemption_12M_10K	no_of_assetclass_sold_12M_1	no_of_assetclass_redeemed_12M_1	no_of_assetclass_sales_12M_10K	no_of_assetclass_Redemption_12M_10K	No_of_fund_curr	No_of_asset_curr	AUM	sales_curr	sales_12M	redemption_curr	redemption_12M	new_Fund_added_12M	sales_2019	new_fund_2019	Channel_Fee-Based Adviser	Channel_Independent Dealer	Channel_National Broker-Dealer	Sub channel_IBD	Sub channel_NACS
9995	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.000	0.000	0.000	0.000	0.000000e+00	0.0	0.0000	0.0	0	1	0	1	0
9996	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.000	0.000	0.000	0.000	0.000000e+00	0.0	0.0000	0.0	0	1	0	1	0
9997	1.0	3.0	1.0	1.0	1.0	2.0	1.0	1.0	1.0	2.0	1.0	1.0	3.0	3.0	130553.620	0.000	23996.160	-1500.000	-2.411757e+04	0.0	43022.9600	1.0	0	1	0	0	1
9998	8.0	5.0	7.0	1.0	4.0	3.0	4.0	1.0	3.0	2.0	3.0	1.0	8.0	2.0	0.000	15996.995	742943.985	-1803.990	-2.174908e+04	1.0	667137.6671	0.0	0	0	1	0	1
9999	10.0	45.0	1.0	0.0	3.0	2.0	1.0	0.0	3.0	2.0	1.0	0.0	0.0	0.0	0.000	1303.230	25421.350	-424.380	-9.747835e+03	2.0	11930.3850	0.0	0	1	0	0	1
10000	12.0	35.0	7.0	28.0	3.0	4.0	3.0	4.0	2.0	3.0	2.0	3.0	8.0	3.0	430089.060	154026.280	208075.030	-155432.540	-1.701681e+06	0.0	914411.0600	4.0	0	1	0	1	0
10001	85.0	64.0	1.0	0.0	7.0	4.0	1.0	0.0	3.0	3.0	1.0	0.0	4.0	3.0	170204.585	12611.290	165413.245	-8412.380	-4.004700e+04	6.0	540906.0000	4.0	0	1	0	1	0
10002	18.0	39.0	5.0	3.0	4.0	4.0	2.0	3.0	2.0	2.0	1.0	1.0	3.0	1.0	0.000	0.000	226534.495	-288519.215	-1.657505e+05	3.0	122282.9700	3.0	0	0	1	0	1
10003	34.0	51.0	5.0	8.0	16.0	20.0	3.0	8.0	5.0	5.0	3.0	3.0	8.0	1.0	0.000	6634.500	201014.070	-8216.830	-3.298782e+05	8.0	207464.2900	0.0	1	0	0	1	0
10004	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.000	0.000	0.000	0.000	0.000000e+00	0.0	0.0000	0.0	0	0	1	0	1

Most frequent

	No_of_fund_curr	No_of_asset_curr	Channel_Bank/Trust	Channel_Dual	Channel_Fee-Based Adviser	Channel_Independent Dealer	Channel_National Broker-Dealer	Sub channel_IBD	Sub channel_NACS	Sub channel_RIA	count
5	0.0	0.0	0	0	0	1	0	1	0	0	1122
1	0.0	0.0	0	0	0	0	1	0	1	0	185
10	0.0	0.0	0	1	0	0	0	1	0	0	105
4	0.0	0.0	0	0	0	1	0	0	1	0	91
26	1.0	0.0	0	0	0	1	0	1	0	0	79
33	1.0	1.0	0	0	0	1	0	1	0	0	56
8	0.0	0.0	0	0	1	0	0	1	0	0	46
13	0.0	0.0	1	0	0	0	0	1	0	0	34
7	0.0	0.0	0	0	1	0	0	0	0	1	32
24	1.0	0.0	0	0	0	0	1	0	1	0	21

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters